package com.ljl.Mapper;

import com.ljl.Entity.Orderlist;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface OrderListMapper {

    //TODO 增加订单信息
    @Insert("INSERT INTO orderlist (customid, orderid, ordernum, orderdatetime) values (#{customid}, #{orderid}, #{ordernum}, #{orderdatetime})")
    int insertorder(Orderlist orderlist);

    //TODO 查询订单信息-全部
    //TODO 查询班级下所有学生的信息
    @Select("SELECT * FROM orderlist WHERE customid = #{customid}")
    List<Orderlist> selectOrderlistByCustomid(int customid);


}
